SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Enfield NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Experience year-round recreation and lakefront living at this stunning log home on the shores of Crystal Lake. Built in 2014 and set on a level .74-acre lot with 401 feet of private waterfront, this exceptional property offers the perfect blend of rustic elegance, comfort lake living with unforgettable outdoor enjoyment. The spacious main level features a desirable first-floor primary suite with a private bath, creating an ideal retreat after a day on the water. Upstairs, you’ll find an additional bedroom, a dedicated exercise room with deck access and lake views, a stylish full bath, providing comfortable accommodations for family and guests. A detached, heated barn with a half bath offers outstanding flexibility for a studio, hobbies, storage, workshop space, or recreational equipment. Whether you’re boating, swimming, snowmobiling, or simply relaxing by the water, this remarkable Crystal Lake property delivers the ultimate four-season lifestyle. Open House Saturday May 30th 10 am to Noon
Description:This charming 3-season home on beautiful 1158-acre Mascoma Lake has been lovingly cared for by the same family for over 50 years, and now it’s ready for its next chapter. Nestled on 0.71 private acres with 210 feet of pristine waterfront, this 3-bedroom, 4-bath retreat invites you to slow down and savor lakeside living. Whether you're floating in the peaceful waters, relaxing in the sunken spa within the detached sunroom, enjoying a sunset from the mahogany deck, or strolling down the quiet, tree-lined road, every moment here feels like a getaway. Listen to the sound of the loons and watch the eagles soar. Nature's beauty is right at your doorstep. A 42-foot aluminum dock with new thru-flow decking stretches into the deep water, ideal for boating, fishing, or simply soaking in the beauty of the surroundings. Cedar shake siding adds timeless appeal, while the whole-house standby generator offers convenience and peace of mind. Inside, floor-to-ceiling windows bring the lakefront views right into the living space, and thoughtful updates throughout provide comfort and function. Though currently used as a 3-season home, it holds the potential to be enjoyed year-round with a few modifications. Here, the days feel longer, the air is a little sweeter, and the lake feels like it’s all your own.